package com.link.base.base.mpconfig.dao.mybatis.mapper;

import com.link.base.base.mpconfig.model.SendTempMessage;
import com.link.base.base.wechat.model.TemTable;
import com.link.core.basic.dao.mapper.BasicMapper;

/**
 * 发送模板消息
 *
 * @author: 闫有霞
 * @date: 2019/12/19
 */
public interface SendTempMessageMapper extends BasicMapper<SendTempMessage> {

    /**
     * @createdBy 闫有霞
     * @date 2018/12/14
     * @methods: queryVauleByOrder
     * @param: temTable
     * @return: String value
     * @description: 以订单表为基准获取参数值
     **/
    public String queryVauleByOrder(TemTable temTable)throws Exception;


       /**
     * @createdBy 闫有霞
     * @date 2018/12/14
     * @methods: queryVauleByTransac
     * @param: temTable
     * @return: String value
     * @description: 以会员交易表为基准获取参数值
     **/
    public String queryVauleByTransac(TemTable temTable)throws Exception;

    /**
     * @createdBy 闫有霞
     * @date 2018/12/14
     * @methods: queryVauleByOrder
     * @param: temTable
     * @return: String value
     * @description: 以优惠券领取表为基准获取参数值
     **/
    public String queryVauleByCoupRec(TemTable temTable)throws Exception;


    /**
     *@createdBy 闫有霞
     *@date 2018/12/14
     *@methods: getWxOpenIdByOrder
     *@param: String paramId   参数记录ID
     *         *@return: String value
     *@description: 获取微信的openId
     **/
    public String  getWxOpenIdByOrder(SendTempMessage entity) throws Exception;


    /**
     *@createdBy 闫有霞
     *@date 2018/12/14
     *@methods: getWxOpenIdByTransac
     *@param: String paramId   参数记录ID
     *         *@return: String value
     *@description: 获取微信的openId
     **/
    public String  getWxOpenIdByTransac(SendTempMessage entity) throws Exception;

    /**
     *@createdBy 闫有霞
     *@date 2018/12/14
     *@methods: getWxOpenIdByCoupRec
     *@param: String paramId   参数记录ID
     *         *@return: String value
     *@description: 获取微信的openId
     **/
    public String  getWxOpenIdByCoupRec(SendTempMessage entity) throws Exception;

    /**
     *@createdBy 闫有霞
     *@date 2018/12/14
     *@methods: getWxOpenIdByDepartureReport
     *@param: String paramId   参数记录ID
     *         *@return: String value
     *@description: 获取微信的openId
     **/
    public String  getWxOpenIdByDepartureReport(SendTempMessage entity) throws Exception;

    /**
     *@createdBy 闫有霞
     *@date 2018/12/14
     *@methods: getWxOpenIdByAppLogin
     *@param: String paramId   参数记录ID
     *         *@return: String value
     *@description: 获取微信的openId
     **/
    public String  getWxOpenIdByAppLogin(SendTempMessage entity) throws Exception;

    /**
     * @createdBy 闫有霞
     * @date 2018/12/14
     * @methods: queryAddressVauleByOrder
     * @param: temTable
     * @return: String value
     * @description: 以订单表为基准获取地址类型参数值
     **/
    public String queryAddressVauleByOrder(TemTable temTable)throws Exception;



    /**
     * @createdBy 闫有霞
     * @date 2018/12/14
     * @methods: queryVauleByDepartureReport
     * @param: temTable
     * @return: String value
     * @description: 以离店报告表为主表获取参数值
     **/
    public String queryVauleByDepartureReport(TemTable temTable)throws Exception;



    /**
     * @createdBy 闫有霞
     * @date 2018/12/14
     * @methods: queryVauleByAppLogin
     * @param: temTable
     * @return: String value
     * @description: 以用户登录表为主表获取参数值
     **/
    public String queryVauleByAppLogin(TemTable temTable)throws Exception;

    /**
     * @createdBy 闫有霞
     * @date 2018/12/24
     * @methods: queryListVauleByOrder
     * @param: temTable
     * @return: String value
     * @description: 获取订单状态的值列表显示值
     **/
    public String  queryListVauleByOrder(TemTable temTable)throws Exception;

    /**
     * @createdBy 闫有霞
     * @date 2018/12/24
     * @methods: queryValueByStore
     * @param: temTable
     * @return: String value
     * @description: 获取门店表中的数据
     **/
    public String  queryValueByStore(TemTable temTable)throws Exception;

    /**
     * 计算积分明细的总积分
     *
     * @author guguishan
     * @date   2019/5/30 21:42
     */
    String querySumByPointBalances(TemTable record) throws Exception;

    /**
     * 获取积分值
     *
     * @author guguishan
     * @date   2019/5/31 15:03
     */
    String queryVauleByPointResult(TemTable record) throws Exception;

    /**
     * 获取值列表对应的comments
     *
     * @author guguishan
     * @date   2019/6/4 10:42
     */
    String queryValueByLov(TemTable record) throws Exception;

    /**
     * 获取小程序的微信openId
     *
     * @author guguishan
     * @date   2019/6/24 17:54
     */
    String getMpOpenIdByTransac(SendTempMessage record) throws Exception;

    /**
     * 获取积分明细本次积分值
     *
     * @author guguishan
     * @date   2019/7/9 20:32
     */
    String querySumVauleByPointResult(TemTable record) throws Exception;

    /**
     * 获取产品信息
     *
     * @author guguishan
     * @date   2019/7/9 20:32
     */
    String queryVauleByProd(TemTable record) throws Exception;

    /**
     * 获取会员信息
     *
     * @author guguishan
     * @date   2019/7/9 20:32
     */
    String queryVauleByMember(TemTable record) throws Exception;

    /**
     * 获取互动记录信息
     *
     * @author 路江
     * @date 2020-1-7
     * @param record
     * @return
     * @throws Exception
     */
    String queryValueByActionInfo(TemTable record) throws Exception;
}
